ABL / BBC Review / Manual Input / BBC Review Data

BBC Review Data

The BBC Review Data page shows a summary view of the BBC receivables-rollforward, receivable collateral, inventory collateral, other collateral, credit line availability and the BBC availability. It is a summary view of details from the BBC Availability page. It shows the current and previous values for quick comparison. You can change the BBC date and Aging date in this page and view the last approved BBC date. 

Table of Contents

Refer to the Screenshot

BBC Review Data page

Fields and Descriptions

Fields Descriptions
BBC Date  Specifies the start date of the BBC. You can change the BBC date only if the selected BBC frequency is 'On Demand' under Create ABL Client page. Refer to the screenshotRefer to the screenshot

Aging Date Allows the user to set a date on which Receivables Aging should be calculated.  
Last Approved BBC Date Displays the date at which last BBC was approved.   
Manual BBC Check in the check box if it is a manual BBC.  
Descriptions Specifies description for the BBC Data.   
Current Value Specifies current value for the unreleased BBC Data. 
Previous Value Specifies previous value for the last approved BBC Data. 

Maintain Current AR Flag

If the  Maintain Current AR  flags are ON under Basic Parameters page, then the invoice aging is calculated based on the Aging date selected under BBC Review Data page.

BBC Others popup


Input BBC Date and Aging Date

To input BBC Date and Aging Date for the receivables, perform these steps: 

1. In the  BBC Date  field, select the BBC Date.

Note You can select BBC date lesser than the system-generated Rollforward activity date as well as New Sales and New credited uploaded through Map and Uploads. You cannot select BBC date lesser than the manually-added Rollforward activity date. 

 

BBC review data page

Prompt message - Recalculate BBC

2. In the  Aging Date  field, select the aging date for the receivables. 

3. Click Save Button. A pop-up screen appears.  


4. Click  OK . The BBC is updated and a message  "BBC Updated Successfully"  appears. 

Success - BBC updated


Upon re-calculating the BBC, the invoice days and the due days are updated based on the aging date under Current Receivables page and Detail Receivables page. The invoice amount gets shifted to the respective Bucket under Summary Receivables  page based on the Aging Date for the receivables. 

Upon modifying the BBC date, the modified BBC date are updated under BBC Availability page and Source BBC column under Collateral Loans page. 


Less BBC Date

If user selects the BBC date lesser than the manually-added Rollforward activity date, then the system shows an error notification. 

Error prompt - BBC date is less than Rollforward date

Invoice Aging Calculation

The following formulas are used to calculate the invoice aging based on the selection of BBC date and/or Aging date:

1. If Aging Date is not selected, then the Invoice aging is calculated based on the BBC Date under Detail Receivables and Current Receivables. The formula is as follows:

Invoice aging = BBC Date – Invoice date/ Due date/ Invoice date +1/ Due date +1.

2. If Aging Date is selected, then the Invoice aging is calculated based on the Aging Date under Detail Receivables and Current Receivables. The formula is as follows:

Invoice aging = Aging Date – Invoice date/ Due date/ Invoice date +1/ Due date +1.

3. If both BBC Date and Aging Date is selected, then the Invoice aging is calculated based on the Aging Date under Detail Receivables and Current Receivables.

Invoice aging = Aging Date – Invoice date/ Due date/ Invoice date +1/ Due date +1.

When user selects the Aging Date, the Aging date is displayed under BBC Executive Trend Report page, BBC Trend Report page, Collateral Analysis - Comparative Report page, Ineligible Trend Report page and BBC Management Report page.

When user selects the BBC Date without selecting the Aging Date, then the BBC Date is displayed under BBC Executive Trend Report page, BBC Trend Report page, Collateral Analysis - Comparative Report page, Ineligible Trend Report page and BBC Management Report page.

Note If user modifies the BBC Date lesser than the Batch date which is generated while doing repayment via Cash Application, then the system deletes all the repayment entries linked with the modified BBC date in Receivables Rollforward page. If user selects the BBC date lesser than the system-generated Rollforward activity date as well as New Sales and New credited uploaded through Map and Uploads page, then the system will not display the system-generated New Cash Collected and New Adjustment values in Receivables Rollforward page. Once user selects the BBC date greater than the system-generated Rollforward activity date as well as New Sales and New credited uploaded through Map and Uploads, the system will again display the system-generated New Cash Collected and New Adjustment values in Receivables Rollforward page.